Course Description

This foundational course presents terminology, basic concepts, and applications of database processing including file organization and data structures. The course emphasizes database design using various modeling techniques; database implementation using the relational model, normalization, and SQL. Students will design, create and process a database to demonstrate competency in the course content.

Prerequisite

Completion of BUSA 2101, ITEC 2215 or CSCI 1101 or CSCI 1301.

Course Objectives

These objectives are directed toward the following general education expected outcomes of the college:

1. Analytical and Critical-Thinking Skills: Students should be able to reason and the think analytically in solving problems and making decisions.

2. Mathematical Skills: Students should be able to understand and apply fundamental mathematical concepts in solving problems.

3. Communication Skills: Students should be able to read and listen with understanding and to communicate clearly and effectively in writing and speaking.

4. Information Technology Skills: Students should be able to appropriately use computer software in solving various problems and accomplishing various tasks.

Upon completion of CSCI 1301, students should have an understanding of:

1. Basic database terminology

2. Explain the advantages and disadvantages of database processing

3. Describe the relational model

4. Use Structured Query Language (SQL)

5. Examine the security feature of a Database Management System (DBMS)

6. Discuss entity, referential, and legal-values integrity

7. Understand how normalization is used in the database design process

8. Discuss the general process and goals of database design

9. Discuss the need for database administration

10. Describe distributed database management systems (DDBMSs)

11. Discuss the general concepts of object-oriented DBMSs.

Required Textbook

Essentials of Database Management. Hoffer, Jeffery, A. Topi, Heikki, and Ramesh, V. (2014). Pearson, Boston.

Grading

Item Percentage

Nine pre-reading tests 20%

Projects/major assignments 30%

Two one-hour tests 50% (total)

Midterm - 25%

Final exam 25%

Projects/major assignments will be completed outside of class and must be your own work. There will be one or more projects for certain units during the semester. Most of these assignments will be computer programs. All assignments are due at the beginning of the class period on the date due. Late projects will not be accepted except in the case of an extreme emergency, which must be documented with a note or phone call. Late projects will receive only 50% of the credited points. No project will be accepted more than one class period past the due date for any reason.

How to compute your final grade

Compute the average your project grades

Multiply the average of your projects by .30

Compute the average of your pre-reading tests

Multiply the average of your pre-reading tests by .20

Multiply the grade on the midterm by .25

Multiply your final exam grade by .25

The Sum of these computations is your final numeric course grade.

Grading Scale

Letter grades for the course are based on a 100-point grading scale as follows:

90-100 = A

80-89 = B

70-79 = C

60-69 = D

below 60 = F

Tests

There will be a midterm and a final exam during the course of the semester. Tests start at the beginning of class and may not be rescheduled or made up if missed excepting extreme emergencies. Late students may not be permitted to enter the classroom. The test grades will together account for 50% of your class grade. All tests are required and none can be dropped.

Final Exam

There will be a comprehensive final examination at our scheduled final examination period in our regular classroom. This final examination accounts for 25% of your course grade.

Missed Test

Normally, makeup tests will be given only in the cases of illness, a death or serious illness in the immediate family, or a similar extreme emergency. Students may be asked to produce written documentation in support of their request (e.g. a note from the doctor or supervisor).

Extra Credit Policies

This course already involves a substantial workload, and it is the instructor's philosophy that students need to focus on the work already assigned rather than taking on additional work. Therefore, there will be no extra credit assignments offered.

Absence Policy

Regular attendance is the most critical factor in your success in this class. You are expected to attend all classes and examinations as scheduled. Students are responsible for “catching-up” after missing a class. I will not provide handouts, class notes, or instructions to a student who has missed a class regardless of the reason. In such cases the student must rely on classmates for help. A student who wishes to withdraw from a class must submit their own withdrawal form to the Registrar's office.

Attendance will effect 10% of your grade as follows:

# of Absences Points Subtracted From the Final Grade

0 0

1 0

2 1

3 2

4 5

5 7

6 9

7 or more 10

This point system applies to ALL absences regardless of the reason. Students arriving after the class roll has been taken will be counted absent.

Before the midpoint, students withdrawing from the course will receive a "W". After the midpoint, students withdrawing from the class will receive a grade of "WF".

Students are responsible for every instruction, every change in the syllabus, and all material covered in class whether or not they are present. Students who enroll in the course late are responsible for material covered before they enrolled.

Classroom Etiquette: Students are expected to treat the instructor and other students with respect. Please refrain from the following during class time:

Talking with other students (other than during classroom or group activities).
Leaving class early (other than an emergency).
Leaving the desk to sharpen a pencil in the middle of a lecture.
Consistently late coming to class.
Pagers beeping during class.
Placing or receiving cellular phone calls during class.

Computer Lab Facilities

For your assignments, you may use the Gordon College writing lab facilities in the academic building room 109 or the computer facilities in the Library at any time that the lab facilities are open. All students are expected to familiarize themselves with the posted lab rules and regulations

Note that the labs exist only to provide access to the college's computer facilities for all students. The labs do NOT provide tutorial assistance with your coursework. The lab staff is responsible for keeping the computer hardware and software functioning properly and monitoring lab usage, not for helping you with your assignments. Although the lab assistants will try to answer your questions about using the computer system, they are not familiar with your assignments, and many of them do not know the materials we are working with. If you are having trouble with an assignment, you need to call or visit me for help.

If you have your own computer at home or work, with appropriate software available, you may certainly use that computer for your assignments.

Academic Integrity Policy

Cheating and/or plagiarism in this class is not tolerated. Students are expected to adhere to the Academic Dishonesty Policy in the Gordon College Academic Catalog. Examples of academic dishonesty involving computers include, but are not limited to:

a. submitting the programs, documentation, or program results of another person as your own;

b. obtaining or attempting to obtain unauthorized access to information stored in electronic form;

c. submitting false results of a program's output for a class assignment or falsifying the results of

program execution for the purpose of improving a grade.

All assignments for this course are to be substantially the work of the individual student whose name appears on the submitted assignment, unless the assignment is specifically indicated, in writing, as being a group assignment. It is your responsibility to ensure that you submit the correct work.

Students are permitted to discuss assignments with one another and assist one another with minor problems as they work on assignments. However, each student is to develop their individual problem analysis and algorithm, and write and test their own program. This allows you to consult with and assist one another as you work on assignments, though your final product is to be your own work. In working on your assignments, you should be extremely careful about giving another student a copy (preliminary or final) of your work or showing another student your work, as this leaves both of you open to a charge of plagiarism.

Any instances of two or more individuals turning in assignments which are identical, either in form or logic, will be regarded as cheating unless either:

1.The logic and structure used in a program is so obvious and straightforward

that it is expected that most students would use this logic in this program, or

2.The logic and structure used in a program follows that of any sample algorithm

for the assignment handed out by the instructor.

Title IX

Gordon State College is committed to providing an environment free of all forms of discrimination and sexual harassment, including sexual assault, domestic violence, dating violence and stalking. If you (or someone you know) has experienced or experiences any of these incidents, know that you are not alone. All faculty members at Gordon State College are mandated reporters. Any student reporting any type of sexual harassment, sexual assault, dating violence, domestic violence or stalking must be made aware that any report made to a faculty member under the provisions of Title IX will be reported to the Title IX Coordinator or a Title IX Deputy Coordinator. If you wish to speak with someone confidentially, you must contact the Counseling and Accessibility Services office, Room 212, Student Life Center. The licensed counselors in the Counseling Office are able to provide confidential support. Gordon State College does not discriminate against any student on the basis of pregnancy, parenting or related conditions. Students seeking accommodations on the basis of pregnancy, parenting or related conditions should contact Counseling and Accessibility Services regarding the process of documenting pregnancy related issues and being approved for accommodations, including pregnancy related absences as defined under Title IX.

ADA and 504

If you have a documented disability as described by the Americans with Disabilities Act (ADA) and the Rehabilitation Act of 1973, Section 504, you may be eligible to receive accommodations to assist in programmatic and/or physical accessibility. The Counseling and Accessibility Services office located in the Student Center, Room 212 can assist you in formulating a reasonable accommodation plan and in providing support in developing appropriate accommodations to ensure equal access to all GSC programs and facilities. Course requirements will not be waived, but accommodations may assist you in meeting the requirements. For documentation requirements and for additional information, contact Counseling and Accessibility Services at 678-359-5585.

House Bill 280

For information regarding House Bill 280, see the University System of Georgia at the following link: http://www.usg.edu/hb280

Religious Holidays

Gordon State College acknowledges that the academic calendar can sometimes conflict with major holidays from among our diverse religious traditions. If a student must miss class due to the observance of a religious holiday, that absence may be excused. To be excused, the student must inform his/her instructors before the absence and make alternate arrangements for any work due at the time of the absence. An excused absence for the observance of a religious holiday does not excuse student from responsibility for required course work.

Hightower Collaborative Learning Center & Library

The Hightower Collaborative Learning Center & Library offers Gordon State students specialized library research assistance. Students can meet with their personal librarians for one-on-one help in each discipline, major, or course to search and evaluate information sources effectively. Go to http://libcal.gordonstate.edu/ to schedule an appointment by clicking the Personal Librarian tab or click on the Room reservations tab to make a reservation. For immediate help, call 678-359-5076 or stop by the Circulation/Check-Out Desk. You can also ask Ask a Librarian or drop by the Circulation/Check-Out Desk. Check the library’s website for operating hours, Electronic Resources, and LibGuides (subject- or class-specific research guides).

Tentative Course Schedule – CSCI 2410/ITEC 2245 Spring 2020

WEEK CHAPTER TOPICS

1 1 Course Introduction, The Database Environment and Development Process

2 1 The Database Environment and Development Process

3 2 Modeling Data in the Organization

4 3 The Enhanced E-R Model

5 4 Logical Database Design and the Relational Model

6 5 Physical Database Design and Performance

7 Midterm Exam

8 6 Introduction to SQL

9 6 Introduction to SQL

10 8 Advanced SQL

11 7 Advanced SQL

12 8 Database Application Development

13 9 Data Warehousing

14 --- Advanced topics as time permits

15 --- Advanced topics as time permits

Important Dates:

Final Examination: Wednesday, 5/6/2020, 2:45 pm – 4:45 pm

Midterm, last day to withdraw with a grade of W – Thursday, March 5, 2020

Spring Break – March 16, 2020 – March 20, 2020